﻿-- =============================================
-- Author:		<Author,XFL>
-- Create date: <Create Date,2011 01 18>
-- Description:	<Description,根据登录账户 username 在用户表中提取 对应的角色参数>
-- =============================================
CREATE PROCEDURE [dbo].[proc_Users_InRolesItem] 
	
@UserName nvarchar(50)

AS
BEGIN

	SET NOCOUNT ON;
Select
	UserName,
	isnull(UserInRoles,'...') As UserInRoles	
	from
	aspnet_Users
	where 
	username=@UserName
END
